A Data Warehouse Architecture for Meteo Swiss: An Experience Report
نویسندگان
چکیده
In this experience report we consider some issues in the development of a data warehouse for meteorological and climatology data at MeteoSwiss. The paper describes the meteorological and climatology data process, the data warehouse architecture developed to support this process while integrating legacy systems and some of the modelling issues encountered.
منابع مشابه
Using Reference Models for Data Warehouse Metadata Management
Based on experience from applying the Common Warehouse Metamodel to metadata management at a large Swiss bank, the applicability of metadata reference models in complex application domains is analyzed. In order to explain the context of the case, the state-of-the-art of the Common Warehouse Metamodel and its application for data warehouse management are summarized. Based on the project experien...
متن کاملKey organizational factors in data warehouse architecture selection
a r t i c l e i n f o Keywords: Data warehousing Data warehouse architecture Archictecture selection Independent data marts Bus architecture Enterprise data warehouse Hub and spoke Federated Even though data warehousing has been in existence for over a decade, companies are still uncertain about a critical decision — which data warehouse architecture to implement? Based on the existing literatu...
متن کاملImprovement of the Analytical Queries Response Time in Real-Time Data Warehouse using Materialized Views Concatenation
A real-time data warehouse is a collection of recent and hierarchical data that is used for managers’ decision-making by creating online analytical queries. The volume of data collected from data sources and entered into the real-time data warehouse is constantly increasing. Moreover, as the volume of input data to the real time data warehouse increases, the interference between online loading ...
متن کاملGlobal Validation of the (a)atsr Meteo Product Sea-surface Temperature
Validation has been performed on the Advanced-Along Track Scanning Radiometer (AATSR) Sea Surface Temperature (SST) Meteo product data at the Met Office on a daily basis. Meteo product skin SSTs have been compared with point measurements of buoy SST, and a 1-degree climate SST analysis field compiled from in situ measurements and Advanced Very High Resolution Radiometer SSTs. These validation r...
متن کاملAcm Tech Pack on Business Intelligence/data Management Bi/dm Tech Pack Committee
The increasing search for computational solutions to support the decisionmaking led to the development of new technologies that aim to transform the large volume of data in information and knowledge useful. The data warehousing technology emerged with the aim of structuring the data in the best way possible to facilitate its access, making the process more efficient and effective. Along with it...
متن کامل